sisHYD User Guide

Import of customer data (text format)

Warning: The following list describes the customer information which can/must be written into the import file. You must follow the conventions and instructions in the following section so that the import can take place error free. At the end of the section there is a list with instructions for the recovery of errors with the import.

For each customer the following information can be set in the import file (Position Description of the field):

  1. Key designator for the network (max. 40 characters).
    • An import filter can be defined for the import function using this. Only the customers whose key designator agrees with the network name are imported (see Network)!
  2. Unique Customer designator (max. 40 characters).
    • Note that the customer names must be unique. Customer records are not imported if a data set with same name already exists!
  3. Assigned and existing Node "no compression" with max. 19 characters.
    • For the network position node names receive a letter identification at the end; "V" stands for a node at the flow leader and"K" for a node at the KLB leader.
  4. Assigned and existing Node for "low compression" with max. 19 characters.
  5. Assigned and existing Node for "high compression" with max. 19 characters.
  6. Designator of the existing Consumer group (max. 40 characters).
  7. Designator of the existing Organization group (max. 40 characters).
    • All numerical values are to be entered in SI units.
  8. Nominal heat output in [W].
  9. Nominal decrease mass flow [kg/s].
  10. Amount of heat taken in the current year [Ws].
  11. Amount of heat taken last year [Ws].
  12. Quantity of water taken in the current year [kg].
  13. Quantity of water taken last year [kg].
  14. Floor space [m2].
  15. Bypass diameter [m].
  16. 1. barrier list1, ignored – formerly LICHEAT.
  17. 2. barrier list2, ignored – formerly LICHEAT.
  18. House name (max. 20 characters).
  19. First name (max. 20 characters).
  20. Road (max. 20 characters).
  21. House number (max. 8 characters).
  22. City/town (max. 20 characters).
  23. Postal/zip code (max. 8 characters).
  24. Private telephone number (max. 14 characters).
  25. Work telephone number (max. 14 characters).
  26. Heat accumulator available (J/N).
  27. Instantaneous water heater available (J/N).
  28. Heat exchanger available (J/N).
  29. Alternative available (J/N).
  30. Volumes taken in the current year [m3].
  31. Volume taken in previous year [m3].
  32. Flow rate [m3].

The customer file must meet the following conditions:

  1. all data of a customer must have been entered in one line
  2. the individual input fields are to be separated by a comma
  3. only the information 1 to 9 is absolutely necessarily; all further details are optional
  4. designators which contain special characters such as commas or blanks must be surrounded by quotation marks (")
  5. designators, in which a comma follows a quotation mark, which contain quotation marks themselves, which have initial or final spaces or tab marks are not permitted